Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	2969
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	301.7 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12
Categorical	1

Alerts

`products` has a high cardinality: 2968 distinct values	High cardinality
`gross_revenue` is highly correlated with `qtd_invoices` and 4 other fields	High correlation
`recency_days` is highly correlated with `qtd_invoices`	High correlation
`qtd_invoices` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`items` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`avg_ticket` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `avg_ticket`	High correlation
`qtd_returns` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 53.59471816)	Skewed
`qtd_returns` is highly skewed (γ1 = 51.73396344)	Skewed
`avg_basket_size` is highly skewed (γ1 = 45.87296489)	Skewed
`products` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`recency_days` has 34 (1.1%) zeros	Zeros
`qtd_returns` has 1444 (48.6%) zeros	Zeros

Reproduction

Analysis started	2022-09-10 19:02:15.938466
Analysis finished	2022-09-10 19:02:45.016064
Duration	29.08 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	2969
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2317.292354

Minimum	0
Maximum	5715
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	185.4
Q1	929
median	2120
Q3	3537
95-th percentile	5035.2
Maximum	5715
Range	5715
Interquartile range (IQR)	2608

Descriptive statistics

Standard deviation	1554.944589
Coefficient of variation (CV)	0.6710178739
Kurtosis	-1.010787014
Mean	2317.292354
Median Absolute Deviation (MAD)	1271
Skewness	0.342284058
Sum	6880041
Variance	2417852.674
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
3011	1	< 0.1%
2996	1	< 0.1%
2999	1	< 0.1%
3000	1	< 0.1%
3001	1	< 0.1%
3002	1	< 0.1%
3005	1	< 0.1%
3007	1	< 0.1%
3008	1	< 0.1%
Other values (2959)	2959	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5715	1	< 0.1%
5696	1	< 0.1%
5686	1	< 0.1%
5680	1	< 0.1%
5659	1	< 0.1%
5655	1	< 0.1%
5649	1	< 0.1%
5638	1	< 0.1%
5637	1	< 0.1%
5627	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	2969
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.77299

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.4
Q1	13799
median	15221
Q3	16768
95-th percentile	17964.6
Maximum	18287
Range	5940
Interquartile range (IQR)	2969

Descriptive statistics

Standard deviation	1718.990292
Coefficient of variation (CV)	0.1125673398
Kurtosis	-1.206094692
Mean	15270.77299
Median Absolute Deviation (MAD)	1488
Skewness	0.03160785866
Sum	45338925
Variance	2954927.624
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
17588	1	< 0.1%
14905	1	< 0.1%
16103	1	< 0.1%
14626	1	< 0.1%
14868	1	< 0.1%
18246	1	< 0.1%
17115	1	< 0.1%
16611	1	< 0.1%
15912	1	< 0.1%
Other values (2959)	2959	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2952
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2794.328222

Minimum	6.2
Maximum	280206.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	6.2
5-th percentile	231.134
Q1	576
median	1106.53
Q3	2338.15
95-th percentile	7345.092
Maximum	280206.02
Range	280199.82
Interquartile range (IQR)	1762.15

Descriptive statistics

Standard deviation	10662.69409
Coefficient of variation (CV)	3.815834522
Kurtosis	346.7828136
Mean	2794.328222
Median Absolute Deviation (MAD)	686.64
Skewness	16.58366173
Sum	8296360.49
Variance	113693045.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
745.06	2	0.1%
731.9	2	0.1%
2092.32	2	0.1%
1031.41	2	0.1%
657.8	2	0.1%
618.09	2	0.1%
178.96	2	0.1%
1418.03	2	0.1%
331	2	0.1%
1353.74	2	0.1%
Other values (2942)	2949	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
63	1	< 0.1%
68.84	1	< 0.1%

Value	Count	Frequency (%)
280206.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
143813.06	1	< 0.1%
124914.53	1	< 0.1%
117375.63	1	< 0.1%
91062.38	1	< 0.1%
81024.84	1	< 0.1%
66653.56	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.11350623

Minimum	0
Maximum	373
Zeros	34
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	241.6
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.47250784
Coefficient of variation (CV)	1.208364858
Kurtosis	2.78857133
Mean	64.11350623
Median Absolute Deviation (MAD)	26
Skewness	1.798770397
Sum	190353
Variance	6001.98947
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
2	85	2.9%
3	85	2.9%
8	76	2.6%
10	67	2.3%
7	66	2.2%
9	66	2.2%
17	64	2.2%
22	55	1.9%
Other values (262)	2219	74.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34	1.1%
1	99	3.3%
2	85	2.9%
3	85	2.9%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	4	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

qtd_invoices
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	59
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.756146851

Minimum	1
Maximum	209
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	209
Range	208
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.920686956
Coefficient of variation (CV)	1.54976709
Kurtosis	193.9643147
Mean	5.756146851
Median Absolute Deviation (MAD)	2
Skewness	10.85129915
Sum	17090
Variance	79.57865577
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	779	26.2%
3	504	17.0%
4	385	13.0%
5	242	8.2%
1	187	6.3%
6	172	5.8%
7	143	4.8%
8	98	3.3%
9	68	2.3%
10	54	1.8%
Other values (49)	337	11.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	187	6.3%
2	779	26.2%
3	504	17.0%
4	385	13.0%
5	242	8.2%
6	172	5.8%
7	143	4.8%
8	98	3.3%
9	68	2.3%
10	54	1.8%

Value	Count	Frequency (%)
209	1	< 0.1%
201	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
93	1	< 0.1%
91	1	< 0.1%
86	1	< 0.1%
73	1	< 0.1%
63	1	< 0.1%
62	1	< 0.1%

items
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1673
Distinct (%)	56.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1609.80229

Minimum	1
Maximum	196915
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	103
Q1	298
median	641
Q3	1401
95-th percentile	4420
Maximum	196915
Range	196914
Interquartile range (IQR)	1103

Descriptive statistics

Standard deviation	5888.984832
Coefficient of variation (CV)	3.658203785
Kurtosis	465.8189735
Mean	1609.80229
Median Absolute Deviation (MAD)	422
Skewness	17.84256245
Sum	4779503
Variance	34680142.35
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	10	0.3%
88	10	0.3%
150	9	0.3%
300	9	0.3%
394	8	0.3%
272	8	0.3%
84	8	0.3%
288	7	0.2%
219	7	0.2%
306	7	0.2%
Other values (1663)	2886	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
196915	1	< 0.1%
80997	1	< 0.1%
79965	1	< 0.1%
77374	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57785	1	< 0.1%

products
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	2968
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Memory size	23.3 KiB

85123A217332173385123A	2
22427224262134022760227702276622788227672282972760B22832824862141122423210802121721844221802250722508215332213822617217182261982484219222260622607226052111582482222962217184968C22180210802075522759227918494523099846092335923108222962184421531215352153921035212172269221524481942309923318229072342423084232412250882484234942343423245233122331423311229102323423353229092260223407214792211121485233552270622141221442311221270221738248323092234092345782494L215332250723374234372337523438234362337321498233492068521523	1
230522305022766230532305121654220872267779030G23054230492305123053230502305223054226802268222683221702309222767230522305185123A221897281222676226792309222766230512165485032D84806B2305023052227662309290030A90030C22676226772267823323233272095623052	1
232052320185123A2198521212221782131422457229697274185169A211222112421986213858506621714213812249979302M847552241321181219772187021874226522283522112224082277985180B84510A22423227762197421671216722167021669216682208921381222952322720829848792247022670231472222485099F23201223862320021928219294819422469475662245785123A2072323204223562320522314700062240923472235312348423543849922121221985475662242385099B22376215772192821929207132238623201233432335684078A224412216922768219832198423378230848497823173226982269723175226992338223480234892352823529235232352723542223852266323343233442280922810229422294185048849457147723313	1
223492230122300227492260622620226072260522998228992290422741227522097722821223842072822728227302296922993229072290522665223842320922273209692097022150221477147721912232292260522570225682311922493209722097122758227542275221935219342238223206207272238322961217912257022569221502214720972209692256422563227412072723209207252266723275221492260721914219152260522693227592256222632226332343922866228652286723493235042350322940221422214122144217312308422554225552255722568209692097020972209712263222633234392286622865228672211222835232092319822666231582294023082230832310023267233892348023084225682262120969209702349323494233552211422835221123597023100230832191422865228672255622554225572349323480217312308422112228352335523083	1
Other values (2963)	2963

Length

Max length	39939
Median length	1478
Mean length	625.1966992
Min length	5

Characters and Unicode

Total characters	1856209
Distinct characters	34
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2967 ?
Unique (%)	99.9%

Sample

1st row	85123A7105384406B84029G84029E22752217302263322632226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522173085123A7105384406B206793737021871210712106882483824868248282494L84029G84029E2275221730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105382483824868248282494L2241184029G84029E227522280321730226322263337370218712107121068824832241184029G84029E217302275285123A71053226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E21730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263384029E22752228032173085123A7105384406B3737021871210712106882483824868248282494L2241184029G226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B373702187121071210688248282494L84029G84029E2275221730226332263285123A7105384406B15056BL2067937370210712106882483824868248282494L84029G84029E2275222803217302263222633
2nd row	848792274522748227492231084969226232262221754217552177748187229602291322912229142175616161P227662270823231850158501622829227222296022961229692272022549209722274384969226222165821756217542175548184226922274822745227492296022722227202097222274849692262322499226072165847566217562175421755219022190121899219002207785123A2315223182231612316023163231622316423177231762300622996230702312623299849692165822423475662162123092231122311023111231182309323089231682323623240231752317323245230322303123029230288505322090220892208885123A217554756622423849692312620972227202315223162231632262316161P21754217552190121900481872311223111231102309323028232452324023173232362318223161231602296023546235452323122720227082298622739234352296022722227202097222621481884818448187230322303185053232452289922367235142351323511231982329423295230252347023397230962348723109234342208685049EM
3rd row	22728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492POST210862108022726227272272822729211212232620750225512255622555217312239022333223312071921883210422236721094POST225402253922556225542255121981226152261622614162182232622492POST2300723010215592104221080210862109421240217312233322331225562255422729221972209022492POST229912300923280232812255622492224342124021238220902272920724207192103921121212122115420983209812124584380POST23100212402123821244212422329822197212102235622466226102260922561POST2272622727227282272916218231242109421080210862155922333POST22728210802109421086229552263622556359702198821989219872255422551POST22081220822208021210211562108021086210942344522326POST2316922326224922103921210226592272622727227282233322466233282338823389233902337323374229912173122778POST221972336823367235062350922629215592115620750220902329822539POST233892235223389233882339022197POST207242348023570233672255522951224172197620719207242235622492226362219722083223262232821207227272272622728227302344523298POST2121223367233682233322991210942108621080219882198921987216802233223598POST230842356222540225442348023084232982290922613226172351522367POST21156223522155922326233882272822726
4th row	22086228432284122839224232290722961225852208422423212322245722084233782312922423220772295023351233502331923354220868494622734229522301323012
5th row	212582125821258

Common Values

Value	Count	Frequency (%)
85123A217332173385123A	2	0.1%
22427224262134022760227702276622788227672282972760B22832824862141122423210802121721844221802250722508215332213822617217182261982484219222260622607226052111582482222962217184968C22180210802075522759227918494523099846092335923108222962184421531215352153921035212172269221524481942309923318229072342423084232412250882484234942343423245233122331423311229102323423353229092260223407214792211121485233552270622141221442311221270221738248323092234092345782494L215332250723374234372337523438234362337321498233492068521523	1	< 0.1%
230522305022766230532305121654220872267779030G23054230492305123053230502305223054226802268222683221702309222767230522305185123A221897281222676226792309222766230512165485032D84806B2305023052227662309290030A90030C22676226772267823323233272095623052	1	< 0.1%
232052320185123A2198521212221782131422457229697274185169A211222112421986213858506621714213812249979302M847552241321181219772187021874226522283522112224082277985180B84510A22423227762197421671216722167021669216682208921381222952322720829848792247022670231472222485099F23201223862320021928219294819422469475662245785123A2072323204223562320522314700062240923472235312348423543849922121221985475662242385099B22376215772192821929207132238623201233432335684078A224412216922768219832198423378230848497823173226982269723175226992338223480234892352823529235232352723542223852266323343233442280922810229422294185048849457147723313	1	< 0.1%
223492230122300227492260622620226072260522998228992290422741227522097722821223842072822728227302296922993229072290522665223842320922273209692097022150221477147721912232292260522570225682311922493209722097122758227542275221935219342238223206207272238322961217912257022569221502214720972209692256422563227412072723209207252266723275221492260721914219152260522693227592256222632226332343922866228652286723493235042350322940221422214122144217312308422554225552255722568209692097020972209712263222633234392286622865228672211222835232092319822666231582294023082230832310023267233892348023084225682262120969209702349323494233552211422835221123597023100230832191422865228672255622554225572349323480217312308422112228352335523083	1	< 0.1%
71053220872208721340	1	< 0.1%
2250122776213404813871459847552242722844224234756622382223842238685099C2072585099B229072129423173226992317023245227202238422386224234756685123A2324323174231752243023582223868248690058B85099C2334490057	1	< 0.1%
21703230482304420972227492256822751230432304423091	1	< 0.1%
84993A8437817107D2230084993B84595E22964474712082921696217132171484804A2307884536B214993744947559B37448	1	< 0.1%
2072522254222552075085014B20682227402320622352226292265922631223822103522895215592290022556225512230321936POST231902319123192232062072521936223522274022328229702230323084POST85014A218832188121880229912299222561223822235221559230842173121452230792072520726226592262922631232062344585014BPOST23084234802335023351233492335322952219762074920750223262255422551225562177022976229642296622992POST23084217312255622555233512334923480229662230322302231152335222328POST	1	< 0.1%
Other values (2958)	2958	99.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
charges	6	0.2%
85123a217332173385123a	2	0.1%
2166822771228052277222774227732277122775228052277322772227712277522772227742277222774228052277522771m217138517484927f84927a84927d208867212272128721278463822796721302171417091a17091j230762156121559224322243122433230772296985036c85036b72803a85036a2243672802a85036a72807c72807b846312096120963226062312822698226992269722423224612277121669216732167221671216682179421793227762167221668227752277322772227742277122805216732166921670230322302823031230292303323034230352277122773227722166921668216732277422771216702166922775227722277222775227712277321672216682167321671216692303223029230312303323034230352167021668216712277522772216692303323028228052166923032227712277521670216682277522771216682167221670216692277122775225602248922805227722167021673216682167122775228052167222771216692277121671230322166821672227752277423028230292167223033216682302823034216692277222775228052166922773216732303322775227712277321672216702167121668216692303523032230342277122774227752277321673216712167021672230332166985175216682303423028233202331923032227742277121670216692277522772	1	< 0.1%
22297227712277222773228052246922197211252112685049c85049d85049e85049g21061210632106284380843782296421213224172121284992219752238320728207272229620728207252072722383223842123222646223182072720728223832238423209207252264622645212312123223089231472314682486221972265022644224692219722469207272072822383232092193185099c2320385099b2192821929824868248385130b85130c2072522384235832330122383232092246922650221972309623452234532229720725	1	< 0.1%
2211022098221002276622451225498474485049e213282296117091a2247384509a84510a22767227682146321464208208515022117211694812982580825788258122413219072244121122228518499122810228092243520966209632096122068217432174484709b2159221587209922266285123a228048248320749207252238220726223842246784625c84625a21108228482103347570b84030e22428225021621884559b84559a22437224368522722983220302119921829212942233222181222712227421989230532305216259475662329821034223542132640001851072332223321233332333423332224602298323109230822103423177851771623621703210982299723501235042350222621227552183223188230842207485049c1622585123a2214422910207582343423435233112340622766227282335282616c23044224912339523393233942278523569235702357184029g2147923319233188401223531227812348621034	1	< 0.1%
22728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492post210862108022726227272272822729211212232620750225512255622555217312239022333223312071921883210422236721094post225402253922556225542255121981226152261622614162182232622492post2300723010215592104221080210862109421240217312233322331225562255422729221972209022492post229912300923280232812255622492224342124021238220902272920724207192103921121212122115420983209812124584380post23100212402123821244212422329822197212102235622466226102260922561post2272622727227282272916218231242109421080210862155922333post22728210802109421086229552263622556359702198821989219872255422551post22081220822208021210211562108021086210942344522326post2316922326224922103921210226592272622727227282233322466233282338823389233902337323374229912173122778post221972336823367235062350922629215592115620750220902329822539post233892235223389233882339022197post207242348023570233672255522951224172197620719207242235622492226362219722083223262232821207227272272622728227302344523298post2121223367233682233322991210942108621080219882198921987216802233223598post230842356222540225442348023084232982290922613226172351522367post21156223522155922326233882272822726	1	< 0.1%
22086228432284122839224232290722961225852208422423212322245722084233782312922423220772295023351233502331923354220868494622734229522301323012	1	< 0.1%
212582125821258	1	< 0.1%
22114217338248482486217542242422505227682175421755217562217084406b8487921136850662279622294224874818848194206858475521621216232296822759227622175648188824862224122288m48185215242242482486222192217084406b221732218948138481942152448111212322125984970l22855222122224121756206858248646000s222198487922189228222152348188847557147784970l22784216732167221669216682284422852228452285348184824862167221754217552166821669216702175521670216692166822578225792257721524481882173321754217552211222577225782257922784222122221923355	1	< 0.1%
2238685099c210332072384997b84997c210942072521559223522121221975219778499184519a85183b85071b219312192922343223452234484519a48188223792238185099b2108021086219758499221210219742266784519b212162193521934219002191184849d2096671496b71495b2186521867219012186647310m218642186722090793212238122379219754811148173c2237921934223802235621900219012190222197207232072420719223552299622995229982299779302m7932147310m2237922381223802209021212461182193221937206752067621901219252193421935216212205348111223862072377101a2235677101a2143046126a2123921240212382124277101a22197210942198979321221792295320724223554611821937219362117248188231822318221034223812237948188219342197479026b22997229952189921900219022190123182219362123821866218642186521867217702117220676206772067579051a47310m2217922995229972318247310m220908482823298793212238023204229532193422356216212116521936211722235523205231822190282551825522267447310m22090793212193521934219372193621936219312238623199229532071923204217702320523182825512299622355223562177023199232012237979321215592072721930219342238685099b210332238622995229982238420728231822318222197211622116323321230802193021931223862320185099c85099f85099b231992238021934219352071920723223552320522356232042072420727207252238447310m21430793212117223321219012190021899219022295322997215582177022379219348255121935207112237921770231824611822995224672334822138217702299647310m2142722674221382261722379223812334820711221382334822467223812348523328217422246722467217702330120728231692358316258a8255221949231942324147310m23471218992190021901235011623621832162372355220986235712249123126231272227422475221912098285135c85136a2299722138214302319223182217542175621930235812238122379	1	< 0.1%
Other values (2964)	2964	99.5%

Most occurring characters

Value	Count	Frequency (%)
2	568777	30.6%
1	193850	10.4%
3	182049	9.8%
8	140316	7.6%
9	133911	7.2%
0	129867	7.0%
4	125320	6.8%
7	121703	6.6%
5	121128	6.5%
6	104084	5.6%
Other values (24)	35204	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1821005	98.1%
Uppercase Letter	35193	1.9%
Space Separator	11	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	8451	24.0%
A	7546	21.4%
C	3827	10.9%
S	2173	6.2%
D	2117	6.0%
L	1834	5.2%
P	1578	4.5%
E	1419	4.0%
F	1252	3.6%
T	1033	2.9%
Other values (13)	3963	11.3%

Decimal Number

Value	Count	Frequency (%)
2	568777	31.2%
1	193850	10.6%
3	182049	10.0%
8	140316	7.7%
9	133911	7.4%
0	129867	7.1%
4	125320	6.9%
7	121703	6.7%
5	121128	6.7%
6	104084	5.7%

Space Separator

Value	Count	Frequency (%)
	11	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1821016	98.1%
Latin	35193	1.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	8451	24.0%
A	7546	21.4%
C	3827	10.9%
S	2173	6.2%
D	2117	6.0%
L	1834	5.2%
P	1578	4.5%
E	1419	4.0%
F	1252	3.6%
T	1033	2.9%
Other values (13)	3963	11.3%

Common

Value	Count	Frequency (%)
2	568777	31.2%
1	193850	10.6%
3	182049	10.0%
8	140316	7.7%
9	133911	7.4%
0	129867	7.1%
4	125320	6.9%
7	121703	6.7%
5	121128	6.7%
6	104084	5.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1856209	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	568777	30.6%
1	193850	10.4%
3	182049	9.8%
8	140316	7.6%
9	133911	7.2%
0	129867	7.0%
4	125320	6.8%
7	121703	6.6%
5	121128	6.5%
6	104084	5.6%
Other values (24)	35204	1.9%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	2965
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.61729517

Minimum	2.150588235
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.929011742
Q1	13.16661017
median	18.18108696
Q3	25.31482759
95-th percentile	90.66859318
Maximum	56157.5
Range	56155.34941
Interquartile range (IQR)	12.14821742

Descriptive statistics

Standard deviation	1035.921865
Coefficient of variation (CV)	20.06927836
Kurtosis	2902.070996
Mean	51.61729517
Median Absolute Deviation (MAD)	6.130240562
Skewness	53.59471816
Sum	153251.7494
Variance	1073134.11
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16.83333333	2	0.1%
15	2	0.1%
4.162	2	0.1%
14.47833333	2	0.1%
18.15222222	1	< 0.1%
12.949	1	< 0.1%
16.29372093	1	< 0.1%
36.24411765	1	< 0.1%
29.78416667	1	< 0.1%
22.8792623	1	< 0.1%
Other values (2955)	2955	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.504876033	1	< 0.1%
2.50837156	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.771005291	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
2027.86	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
835.864	1	< 0.1%
643.8585714	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.35143043

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	25.92857143
median	48.28571429
Q3	85.33333333
95-th percentile	201
Maximum	366
Range	365
Interquartile range (IQR)	59.4047619

Descriptive statistics

Standard deviation	63.54282948
Coefficient of variation (CV)	0.9434518178
Kurtosis	4.887703174
Mean	67.35143043
Median Absolute Deviation (MAD)	26.28571429
Skewness	2.062908983
Sum	199966.397
Variance	4037.691178
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
4	22	0.7%
70	21	0.7%
7	20	0.7%
35	19	0.6%
49	18	0.6%
21	17	0.6%
46	17	0.6%
11	17	0.6%
1	16	0.5%
Other values (1248)	2777	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	22	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1350
Distinct (%)	45.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.06327172298

Minimum	0.005449591281
Maximum	3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.009433962264
Q1	0.01777777778
median	0.02941176471
Q3	0.05540166205
95-th percentile	0.2222222222
Maximum	3
Range	2.994550409
Interquartile range (IQR)	0.03762388427

Descriptive statistics

Standard deviation	0.1344819335
Coefficient of variation (CV)	2.125466593
Kurtosis	121.5596918
Mean	0.06327172298
Median Absolute Deviation (MAD)	0.01433823529
Skewness	8.773426515
Sum	187.8537455
Variance	0.01808539044
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1666666667	21	0.7%
0.3333333333	21	0.7%
0.02777777778	20	0.7%
0.09090909091	19	0.6%
0.0625	17	0.6%
0.1333333333	16	0.5%
0.4	16	0.5%
0.25	15	0.5%
0.02380952381	15	0.5%
0.03571428571	15	0.5%
Other values (1340)	2794	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
3	1	< 0.1%
2	1	< 0.1%
1.571428571	1	< 0.1%
1.5	3	0.1%
1	14	0.5%
0.8333333333	1	< 0.1%
0.75	1	< 0.1%
0.6666666667	12	0.4%
0.6514745308	1	< 0.1%
0.6	1	< 0.1%

qtd_returns
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	216
Distinct (%)	7.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	63.12428427

Minimum	0
Maximum	80995
Zeros	1444
Zeros (%)	48.6%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	9
95-th percentile	103.6
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	1513.12627
Coefficient of variation (CV)	23.97058893
Kurtosis	2760.800218
Mean	63.12428427
Median Absolute Deviation (MAD)	1
Skewness	51.73396344
Sum	187416
Variance	2289551.108
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1444	48.6%
1	177	6.0%
2	153	5.2%
3	107	3.6%
4	90	3.0%
6	72	2.4%
5	64	2.2%
8	49	1.7%
12	48	1.6%
7	47	1.6%
Other values (206)	718	24.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1444	48.6%
1	177	6.0%
2	153	5.2%
3	107	3.6%
4	90	3.0%
5	64	2.2%
6	72	2.4%
7	47	1.6%
8	49	1.7%
9	38	1.3%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8060	1	< 0.1%
4627	1	< 0.1%
3768	1	< 0.1%
3335	1	< 0.1%
2975	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1920	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	1968
Distinct (%)	66.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	245.9893671

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	103.2
median	172
Q3	279.8
95-th percentile	597.8
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	176.6

Descriptive statistics

Standard deviation	784.142945
Coefficient of variation (CV)	3.18771073
Kurtosis	2342.591386
Mean	245.9893671
Median Absolute Deviation (MAD)	82
Skewness	45.87296489
Sum	730342.431
Variance	614880.1582
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
82	10	0.3%
190	8	0.3%
73	8	0.3%
136	8	0.3%
86	8	0.3%
60	8	0.3%
75	7	0.2%
288	7	0.2%
Other values (1958)	2884	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
3684.47619	1	< 0.1%
2880	1	< 0.1%
2697.465753	1	< 0.1%
2183.2	1	< 0.1%
2160.333333	1	< 0.1%
2141.5	1	< 0.1%
2082.225806	1	< 0.1%
2000	1	< 0.1%

avg_unique_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1015
Distinct (%)	34.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.04850801

Minimum	1
Maximum	300.6470588
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	3.5
Q1	10.09090909
median	17.25
Q3	27.71428571
95-th percentile	56.7030303
Maximum	300.6470588
Range	299.6470588
Interquartile range (IQR)	17.62337662

Descriptive statistics

Standard deviation	18.95331893
Coefficient of variation (CV)	0.8596191143
Kurtosis	23.52827499
Mean	22.04850801
Median Absolute Deviation (MAD)	8.25
Skewness	3.175447774
Sum	65462.02028
Variance	359.2282983
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	54	1.8%
14	44	1.5%
11	35	1.2%
9	32	1.1%
20	31	1.0%
1	31	1.0%
10	28	0.9%
17	27	0.9%
17.5	27	0.9%
15	27	0.9%
Other values (1005)	2633	88.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	31	1.0%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	9	0.3%
1.555555556	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%
1.9	1	< 0.1%

Value	Count	Frequency (%)
300.6470588	1	< 0.1%
203.5	1	< 0.1%
149	1	< 0.1%
145.3333333	1	< 0.1%
136.25	1	< 0.1%
135.75	1	< 0.1%
127	1	< 0.1%
122	1	< 0.1%
118	1	< 0.1%
114	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qtd_invoices	items	products	avg_ticket	avg_recency_days	frequency	qtd_returns	avg_basket_size	avg_unique_basket_size
0	0	17850	5391.21	372.0	34.0	1733.0	85123A7105384406B84029G84029E22752217302263322632226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522173085123A7105384406B206793737021871210712106882483824868248282494L84029G84029E2275221730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105382483824868248282494L2241184029G84029E227522280321730226322263337370218712107121068824832241184029G84029E217302275285123A71053226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E21730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263384029E22752228032173085123A7105384406B3737021871210712106882483824868248282494L2241184029G226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B373702187121071210688248282494L84029G84029E2275221730226332263285123A7105384406B15056BL2067937370210712106882483824868248282494L84029G84029E2275222803217302263222633	18.152222	35.500000	0.486111	40.0	50.970588	8.735294
1	1	13047	3237.54	31.0	10.0	1391.0	848792274522748227492231084969226232262221754217552177748187229602291322912229142175616161P227662270823231850158501622829227222296022961229692272022549209722274384969226222165821756217542175548184226922274822745227492296022722227202097222274849692262322499226072165847566217562175421755219022190121899219002207785123A2315223182231612316023163231622316423177231762300622996230702312623299849692165822423475662162123092231122311023111231182309323089231682323623240231752317323245230322303123029230288505322090220892208885123A217554756622423849692312620972227202315223162231632262316161P21754217552190121900481872311223111231102309323028232452324023173232362318223161231602296023546235452323122720227082298622739234352296022722227202097222621481884818448187230322303185053232452289922367235142351323511231982329423295230252347023397230962348723109234342208685049EM	18.822907	27.250000	0.048780	36.0	139.100000	17.200000
2	2	12583	7281.38	2.0	15.0	5060.0	22728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492POST210862108022726227272272822729211212232620750225512255622555217312239022333223312071921883210422236721094POST225402253922556225542255121981226152261622614162182232622492POST2300723010215592104221080210862109421240217312233322331225562255422729221972209022492POST229912300923280232812255622492224342124021238220902272920724207192103921121212122115420983209812124584380POST23100212402123821244212422329822197212102235622466226102260922561POST2272622727227282272916218231242109421080210862155922333POST22728210802109421086229552263622556359702198821989219872255422551POST22081220822208021210211562108021086210942344522326POST2316922326224922103921210226592272622727227282233322466233282338823389233902337323374229912173122778POST221972336823367235062350922629215592115620750220902329822539POST233892235223389233882339022197POST207242348023570233672255522951224172197620719207242235622492226362219722083223262232821207227272272622728227302344523298POST2121223367233682233322991210942108621080219882198921987216802233223598POST230842356222540225442348023084232982290922613226172351522367POST21156223522155922326233882272822726	29.479271	23.187500	0.045699	51.0	337.333333	16.466667
3	3	13748	948.25	95.0	5.0	439.0	22086228432284122839224232290722961225852208422423212322245722084233782312922423220772295023351233502331923354220868494622734229522301323012	33.866071	92.666667	0.017921	0.0	87.800000	5.600000
4	4	15100	876.00	333.0	3.0	80.0	212582125821258	292.000000	8.600000	0.136364	22.0	26.666667	1.000000
5	5	15291	4668.30	25.0	15.0	2103.0	22114217338248482486217542242422505227682175421755217562217084406B8487921136850662279622294224874818848194206858475521621216232296822759227622175648188824862224122288M48185215242242482486222192217084406B221732218948138481942152448111212322125984970L22855222122224121756206858248646000S222198487922189228222152348188847557147784970L22784216732167221669216682284422852228452285348184824862167221754217552166821669216702175521670216692166822578225792257721524481882173321754217552211222577225782257922784222122221923355	45.323301	23.200000	0.054441	29.0	140.200000	6.866667
6	6	14688	5630.87	7.0	21.0	3621.0	2238685099C210332072384997B84997C210942072521559223522121221975219778499184519A85183B85071B219312192922343223452234484519A48188223792238185099B2108021086219758499221210219742266784519B212162193521934219002191184849D2096671496B71495B2186521867219012186647310M218642186722090793212238122379219754811148173C2237921934223802235621900219012190222197207232072420719223552299622995229982299779302M7932147310M2237922381223802209021212461182193221937206752067621901219252193421935216212205348111223862072377101A2235677101A2143046126A2123921240212382124277101A22197210942198979321221792295320724223554611821937219362117248188231822318221034223812237948188219342197479026B22997229952189921900219022190123182219362123821866218642186521867217702117220676206772067579051A47310M2217922995229972318247310M220908482823298793212238023204229532193422356216212116521936211722235523205231822190282551825522267447310M22090793212193521934219372193621936219312238623199229532071923204217702320523182825512299622355223562177023199232012237979321215592072721930219342238685099B210332238622995229982238420728231822318222197211622116323321230802193021931223862320185099C85099F85099B231992238021934219352071920723223552320522356232042072420727207252238447310M21430793212117223321219012190021899219022295322997215582177022379219348255121935207112237921770231824611822995224672334822138217702299647310M2142722674221382261722379223812334820711221382334822467223812348523328217422246722467217702330120728231692358316258A8255221949231942324147310M23471218992190021901235011623621832162372355220986235712249123126231272227422475221912098285135C85136A2299722138214302319223182217542175621930235812238122379	17.219786	18.300000	0.073569	399.0	172.428571	15.571429
7	7	17809	5411.91	16.0	12.0	2057.0	229612294322617225692256884032B84032A227492294022909226522291022585215232262421523226244813823284232982298822366214632146422334210342233310120162352243921914212202132920974218292328423382229092295022910221412214223312225852296122561231882299122992231928469223300843478434723300231882214222141232982236623300	88.719836	35.700000	0.039106	42.0	171.416667	5.083333
8	8	15311	60767.90	0.0	91.0	38194.0	221398485422411825672167222774227717127022262226372193421169211662117537444A37444C220862208384971S7127047580222618483222644215332155715056BL15056N226462217622438217312277822719215232262022778849462103384865211722150484563A84563B2250221867216722167337444A2277585035B22775843782263722891218992208382613B82599211582208685014A374462235521258793213744935004C84559B84997D4758084415B2065522170206772123922088220902090622262221752217621243220832109837444B2193422646373332121221872212598486584997D22086226208497884050212582290984997D84997C212442067521240215592289184946226444758021470227882276622261222622156372598225028248615056BL7932135004C82494L225022082922778228442264421731228452173185184C227742290922910824864000115056N228342075022788208292177421231207192072685035B793212080248173C2075082567848362167084849D229092284522746225632256222756219492124321245206772067484997D84997C84997B826002272321832223132244585136A7932148111222422271985099B35004C21668793212208721258221982217184997D84997C824838248615056BL84563A22891215592156121558223522165884509A2173121169223842209047580217732252385036A21988219892089782613C21899848322138021670216692167121672216732226221445214472143920675826002075020829223252156321564211212277521380222412177437449217732237821240212382106884970L84970S84989A2115521243212442124522909206752067422620207332112175049L8475521672216718248484947849468515284997C84997A84997D228052277121931223558248485099F2117582599207252072722384207282071920718207242067720675206742067684997B212422210384993A21244212432124521240212392123820676212122277422775227732277222845228442257182001S207272271921774218818248221754211642280521242206762108021212212388483621121218442264584970S15056N215582103521041475802075420718207242235615056N35004C79321227782284521658843782067622352216712167321669216702167284997D84997C2072521240210682123121210210802198921242212442124521243211232175485099F2071321930219282241121934217732072521668227742167021669216712167321754218992124321244220888259984997B84997D84997C84997A84509A84510A222622184472799F206752067720674206762156185099C85099F2071922356217312284437448221972206185232A2241184520B22088215592155884997C2165822494212442124521033215592156121558206752175485099B84997B84997D2217572760B2112222494215632156484997C84997A216732167221671216702166922774217312193415056N224942247021329213282132722262227752277421669216702290822908219892250279321215232208784509C84946213132067915056N222622217084970S22171474214742222470213272263722325227882082922313217332252185032B2138085019A2186721867214392289185163B1601621755848652155785167B848322211247559B4758021035848368437821658219472194921899215632156417136A2112121122206653733321166211698258182567825832227822276211632115984912B214702146784849D84971S84997C84997A2208922090220882075084596B84596F22176216732116421987219892068522646207282210321564217332112184378222622061884949211758515285014A15056N85014B851502155672760B84559B227522224185163B221712215122152221752231822170222472189984971S2167321672216712167020750215572277222241848368518722361223632236421122222622216272760B8520085150825992116915056BL15056N2217622318222428497822778227752166922774824862192820713207122193137444B37444A84849D2226222620851872145647590A2231885205B35920848362138917136A84997A22284215638248322121359242117584949227732155884849D2194784912A15056BL15056N219302211222291222762082985185B2216235637A215633592185163B85099C223522193121673226452072522087359242145615056N217552167222771228052228485205B21380226372226284997A84997D20829219492241147580215638483285188A223552217184509A22772216712167285185B2072684849D84832222812277020733211662132784510A2065585188A21470211102144522090208292235215056N222412175584865213292116985071D82567214702208621121219472188320655213802226220665210352192921928224112166821754400012071922719228442072479321216692072585099B2072784946212402067521244210332193182001S85099B82482213138497821314226632241122385222812111022613220882290822805227732175515056N825832082947590A2066585071D85071A84849D224182242084563A2147072799F8248421240215232067721243212442067521239211652116637444C37444A84750B84849D2198721121211222153782613A851872228184997A226632224182583824868248372760B79321212388497822364228452224175049L4742147590A2277122805206552123922325222628248384997A223182278815056N85014A21470215592217120725219312072622355216682208717129F21080215234818721558216722167021673216692271922774227722217122170213862229121169217312262085232A21755219342228185150211692143921380220902208922088225258518782483213142131385099B2193622101207282131375049L2121848173C4818548111481162124222197714598497822087824838248622104848328494621989225258515221755213802173320829206658437821035215578258184912A2209022321224112103385188A22291359212275221389215632156422771228052208782494L218844758021563215642252120829213802246722778849782271917129F219313744621035214702116622089225232065584997A85200213892229122525225582275522758227562275322754227578494982613C2138085188A215642275822757227562275522754227532198722243826002208885205B21171224112319923201232052320422661232052320823206851972228115056P2145921212216692167122355712792195582001S85099B2277522355223562072320724223832072622382223842072520727207282241121929226632193020711223852103321928223862193120712211758515222670231822267122672226752267422673850532245715056N15056P2144784563A2227882613A206558494922637226202262021731223322233122333223342209022089220882208722908213272132922281847892101221564220872075021928219292241120750221752156484997A221622215184949208292213922457219342319923201851522117584832226202186485014B15056BL15056N2208821931223844000320676206742072775049L84755849787145922386207122241185099F85099B227782167321672216702166921668217922266321211219882279620750218992140884997D21380227662217584997A21731231402314121115217332156321564211662116482600232564758015056N15056BL21557226372213921033223852192822457849782316885099B2193020711224272238685099F21931207192071221929226612238322382207182308484997C2319223191231902316523167231662237946138B2320621559221522156346138B232062241122178219312213921929223862266385099C85099F22386207122237921175712702186747590B22766226612071923208475802238315056N207282082920726207242072322356212452124284997A84997B232052320885099F22386207122192985099C84510A2320422383232012209084509A85099C23208231992238621929207272071220718228962071923205207262072385099F2325622382207282238422139216702308415056BL2275284692227572275822756232052235620724207232072620725219292103385099F85099B8497875049L17129F8248422774227722277121314227782316815056BL15056N84849D82613D826002227884997A84997C71270712702115922663211692275221467211152143984997B84997D22891227582155784970S20829213802173122382220832111548194226612072722663207192303423035230332242722103714772238217129F82001S20685232042071923206207282319923201224112238685099B21928219312189984596B84596F2111521166215562117121163213802173115056N15056BL22083826002156484347212312208321559224112193185099C2308923084217311600882001S21137227552275621787214472204121175211792116923182211942120815056N2067921557223162319247590A211242319623197231982242622278223158505384596F2328523286232872328818097C228912235447559B47580231992266385099B17091J2257122572210332238647590A2156321557227522111082613D17091J15056N206792173123201223852316623165231632242623182226712303520829220452167322548217902267022409224072240622408224072217921980219832198522615224682198221984219672261647310M2071221137160084811185159A85159B219302071185014B82613D22671208292121120898218672275622753227582275722754227552262022139231822215121447212328248622905229042290323197162252319223190229082178747351B2238675049L223602303322426230352308921716217152277371477227732277422041217182142821672216692290816225224672066584347229052116922671231822319823196231971600885014B15056N15056BL21671216682152348187231682303484569A84569D15056BL15056N20711219302071282600207262072421669216682167121670216722310417129F2113722467824862124585099F2192922775232062238322384207271600821731231822319647310M208292113721718217152318222316227552240923166231672319823197223152231615056BL71459207331600815056N15056BL22316231822277547310M22178231672267084970L2221922139214242142623198231962319723198217542240622409219862179121790226702178721930223862319985099C226702198222409217872247648173C15056BL22755211372131347310M82001S2316822197220412231648173C15056BL15056N85099B2267523201225482318272802A2213547351B1600823198712702121021424214272142822406217182171621467231672308922315223642277817129F213137147775049L8497847351B23168231652284482001S21137160082275215056BL15056N22620217552175448173C21934226372308922409214302240722408224104748047471217312267022665221512275722756227582275322754227552319823197231962267221447208292217421428228918256782600211752267521425214272290422905229032179021791225482254916225224062171822560222972198721439218672065584997D84997C84997A84997B221392293922990214702070479302M21989217152171622134231542210148173C221782235221470216692277385099C2316723166223862071322674226752232622328223272232922410227552233322411207122193021929219342267522670226732267415056N15056BL2303123029230322302822758217872082922646226452318446118214282217922326227212236223403219282192922663207112241121930207122217322682226832268022681226842268522670226792268622677226712267222673226782267684406B2314723146231482082922427227582232684949221322213379066K2318247563A84912A221398483220655213292189921327224292194723016215312264422637221792116621867209862250085014B85014A213802275221684231842153023142228982289921523230892242715056BL21791222162179022904230361622522644226462192920711211662227822674226912269222414223652236685014A206792316921110850531622523190231922319122754226202278144089C44089A8434721327213292231822085226712290421380226282257185099B79066K2238621928475802268622685226812233122406843472266321561215592113720713233152331623317214272241023026231632189222310215302264422646232752264522757219342268321427212573592422227231972275522686226852267622671218822188022326214702303184970L2120721166211652232715056BL8434784510A208292213984509A2316822467231662316585159B217747145948184231692208385099C22411207122268622676226702267722679226812302923032227582327522409218122318221086223322233315056N15056BL16008226632193421121226802267623032221712267715056P2331622366226202231085014B2132921791213272117422326227582198721881223312227621530227562188221812218112186421866230312275722162475802233222333212574818479302M4818522678226832314715056BL2173122326232752303122677226862268023148222972290521232217902236684600215302303221811227552213917091J211372121022686226782268322682226762267722685212588460084510A23275226208434715056BL208292267421731222278494784347215582314822663215302275821012229042213921094207132246822905226792275822755230322217521530224262104184510A23147226718434715056BL21755215312263722386219342319622758222272155822904843752173122161226822267722678843472240723169224672125884947211372275522758231682327548173C849472242616008225562319722572225712213921879218832188121880226202193422426229622296322227221392314716008843478248684510A22753227572138015056BL15056N23031231462241115056N15056BL21773227572181122904229052290322227226852268222683226782267622671226772268022670226812268422686226792267222754227562275322673226752267423163160082318222310211212188384375231462186722175851502116421169851522117521530224682217921211211642198821557226204742120679220652296322962211372316823166231672238620712227782213922844219342193021929219282131375049L84945847924811182483824822266385099C224112217182001S217312143915056P21987843472206582486206852222723271223332115947559B2082923397481872181184347218922314821812220782101222227223652242623168207112179122152215302275422753227562275723317233152250072800E160082184422227231962318422310217872267421880218822192822663221792082921892843752242920712220832316922467725982222735001G211101601621949218998483684347211694811684970S2067979302M8505321012233972236547563A21470214282082923026232752238685099C224114818821169207182072485099B223278469223031213808520285204852032319784347233162331522265207132279415056BL2204121169843472278123315233162275584971S442354423444235227582275523197226912113721258224142152448116231692331523316233172179022678222622189222227217182171623184231962193185099B84347224108494523147231482240647310M79302M22905461188497822752212582332621313481872331723197210122222722794231822175585053231102116921258231682316721314211374423484347	25.543464	4.144444	0.315508	474.0	419.714286	26.142857
9	9	16098	2005.63	87.0	7.0	613.0	1000221912218322241122379223812279822726229262283922838227832292622782224112091422381206812269022730227282272722381223792241122926230942241184673B84673A21888230802238122992224112272622730227272272520914230942299222411150392091484077227282272923315233162273022725227262272722728227292272722730227252241122726227262191221888847542321523214	29.934776	47.666667	0.024390	0.0	87.571429	9.571429

Last rows

	df_index	customer_id	gross_revenue	recency_days	qtd_invoices	items	products	avg_ticket	avg_recency_days	frequency	qtd_returns	avg_basket_size	avg_unique_basket_size
2959	5627	17727	1060.25	15.0	1.0	645.0	8505321928219292358123203229962300484978849462205122986232312354616156S215232269248187235972329822169221702309323408824822299047591D22965229892242522429224268505923243233372333523198219772330723295226242262722720232452297922980229782298122982229932349522722227232290723104225572255522556225512255423370233662143023236232402179022622	16.064394	6.0	0.285714	6.0	645.000000	66.000000
2960	5637	17232	421.52	2.0	2.0	203.0	843472148423356228162281823695220302077723439228662076620764228672286523494234932334422142229662208122991207612158421484843472357622144233192076123240224282286522726228672272723344	11.708889	12.0	0.153846	0.0	101.500000	18.000000
2961	5638	17468	137.00	10.0	2.0	116.0	2320422460212312259621070	27.400000	4.0	0.400000	0.0	58.000000	2.500000
2962	5649	13596	697.04	5.0	2.0	406.0	2262523345233462297823580231162285121136848422296184997A2236722899232752294921080232542171522450849922325622429223602329321877219758499123173220912327523289232902197223313233382296621592229552295122326218778498821034481872197523372229512241723296235752324123177235602334522630235082331322948224172295122630226292308423306232032339023494234932334323299227542290922910229032337122551235082248921878226232254921889225302254323320232852328823286232872308422534225442255623510233892294823598225632256222093227302340122111216152330722093234092337123241231932319421913230802242321888216212187822554226622238222499233902251622517225142251521715217182337284978231302244522450224462319723529216152319822489233722337123377849918497822485220912113622956232712246022178232452323922813231902274622748231772319423241232422179023367233462336823345	4.199036	7.0	0.250000	0.0	203.000000	83.000000
2963	5655	14893	1237.85	9.0	2.0	799.0	85183A2278220749222772193122380232022245722089216422331079302M2308222780230792231021314224232289422907229082227884912B2116717084N17091J2207522580235812149722438224392218170007217902170521703229602137722467229692110884031B84032B84032A84031A2236147421850662311085183B233532349285049A2290922818224568248485152825822117521174211812190821166219072315523200231992320385099F85099B23202	16.956849	2.0	0.666667	0.0	399.500000	36.500000
2964	5659	12479	527.20	11.0	1.0	385.0	21212212102108021086219892198721558212112121321882224378499222993226282121623243212172272021088219882109422215227342207785049E85049C20978209792097323370POST	17.006452	4.0	0.333333	34.0	385.000000	31.000000
2965	5680	14126	706.13	7.0	3.0	508.0	22274221502227322779226212245785123A2096122605224332147923444209632256020961	47.075333	3.0	1.000000	50.0	169.333333	5.000000
2966	5686	13521	1093.65	1.0	3.0	736.0	2353523301233002332022138228352211385177226512187823084851782262185039A21313219142145422620235702299323251218182181021819710502149435471D233272332621135230748497823367216842214422150218892179023189226592249484347216162162021615850592181821819221162117221905230602328121446234982342223420220912272784625A2301323014224812286322972229742332882551224022132985032A85032B85032C232932283122196210662299323293232942329521314224282218222961233682336523366235522349722196221952334023382230842259222842228402242922208222082220922211215342152821537359673596423163231622236747591D215922235222945232492325023251214942297722977210122348922071220702332022509223652277022605226072330123300219122254923526216192171384031B2067915056N229522211323356228352211122695221962295223295224242159284032B2339423396233952339321714233282353523536230892140121400233388498822190234942191422546851782318222673226712178721914210642255785231B232418505322118221192301923080848322308421718214942342222494840122329522642843752219621790219162212322942212792281122457224092240622398224002240021716224412296085061W2306023281234252241984707A22076220752247623169224742316935471D2332884947229642310123100234183597023168232952295623489226392264222638226432321421818218192181022956234952355223498234972329623293232952329421263M2250915056P20679206862217023084209922198421790235042209123376235062351022280222792295285176227272238923367225572255190214E2253022546225442254422533225342214422744227432349390214P90214I22651218782173921064207332198421705233002330122500216192308022940209722215085015150392262122500211152189121890220962275420996218942314421260213132138384993A848792113621718225222318985169A85169C85026B2249521494230742330922132220992339820986220972162085231B21976849918497822139214392267121172231882199321329235512110922119224732247422209224222339947469223982240223356221112283522113221102221022211222082144679063C22620231222163821640209752299322075220742207622481225632256222564222762207222109221082212484596B23252224752334022314229387000623368233662097522561229552247284819215912159284692359702264222343221962156322195215302197723123208682171522638226432321221162232812338223100218192181023212232152181021808218032295522956233202209422942	2.508372	4.5	0.300000	0.0	245.333333	145.333333
2967	5696	15060	303.09	8.0	4.0	263.0	22485224562346123090214942115484876B84877B215922199135471D85049A85049E235622298223100232752308422616229522125822597227342369485049A2202822209229522226635810B2161621619216158511185183A22500233952339422654231982235822507222782103485177233782261623376233782357117012D17012B2115485049E22734225858517685183A85049A225782257723359219912220922952222082337822597225782257785111226972346123090223782346185049E233542159221080226542310023275233522335122358235702211516254M21616216152161935471D85032B223492234884877B84876B84876B2198085032C22754227552075520777223482339423395214282103422456206682245622030224022329123292234992191621991	2.504876	1.0	2.000000	0.0	65.750000	30.250000
2968	5715	12558	269.96	7.0	1.0	196.0	227122334485099B2320979191C233928482823158215072150822027	24.541818	6.0	0.285714	196.0	196.000000	11.000000

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows